﻿

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_TargetDPI_Tbl_Ins]
	-- Add the parameters for the stored procedure 
	@TargetDPI int,
	@CMMMin float,
	@CMMMax float,
	@Nylon bit,
@SPF float,
                @SCoM float,
                @MPF float,
                @MCoM float,
               @LPF float,
                @LCoM float,
               @SYPF float,
                @SYCoM float,
               @EPF float,
                @ECoM float,
               @DPF float,
                @DCoM float
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

INSERT INTO TargetDPI_Tbl (TargetDPI, CMMMin, CMMMax, Nylon, SPriceFactor, SCoM, 
MPriceFactor, MCoM, LPriceFactor, LCoM, SYPriceFactor, SYCoM, EPriceFactor, 
ECoM, DPriceFactor, DCoM) 
VALUES (@TargetDPI, @CMMMin, @CMMMax, @Nylon, @SPF, @SCoM, 
@MPF, @MCoM, @LPF, @LCoM, @SYPF, @SYCoM, @EPF, @ECoM, @DPF, @DCoM)
END